package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.*;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "t_pay_pingan", simpleName = "", engine = MysqlDriver.InnoDB, comment = "支付流水表")
public class _DDL_PayPingan {

    @_DDL_Primary()
    @_DDL_Column(name = "id", type = SqlType.BIGINT_UNSIGNED, nullable = false, comment = "与时间有段的id")
    private java.math.BigInteger id;

    @_DDL_Column(name = "amt", type = SqlType.DECIMAL, size = 8, scale = 2, nullable = false, comment = "交易金额(元）")
    private java.math.BigDecimal amt;

    @_DDL_Column(name = "ch_mer_id", type = SqlType.VARCHAR, size = 30, comment = "第三方商户id")
    private String chMerId;

    @_DDL_Column(name = "state", type = SqlType.TINYINT_UNSIGNED, nullable = false, comment = "交易状态")
    private Integer state;

    @_DDL_Index(name = "IDX_t_pay_pingan_date")
    @_DDL_Column(name = "date", type = SqlType.INT_UNSIGNED, nullable = false, comment = "交易日期")
    private Long date;

    @_DDL_Column(name = "err_msg", type = SqlType.VARCHAR, size = 300, comment = "失败原因")
    private String errMsg;

    @_DDL_Column(name = "err_code", type = SqlType.VARCHAR, size = 20, comment = "失败代码")
    private String errCode;

    @_DDL_Column(name = "ch_id", type = SqlType.VARCHAR, size = 30, comment = "第三方交易流水")
    private String chId;

    @_DDL_Column(name = "ch_time", type = SqlType.TIMESTAMP, comment = "第三方交易时间")
    private java.sql.Timestamp chTime;

}
